package personal.model.dao;

import java.sql.SQLException;
import java.util.List;

import personal.model.vo.AdminVO;
import personal.model.vo.DeptVO;
import personal.model.vo.GradeVO;

public interface CodeManagementDao {
	public void insertDeptCode(DeptVO deptVO) throws SQLException;
	public void insertAdminCode(AdminVO adminVO) throws SQLException;
	public void insertGradeCode(GradeVO gradeVO) throws SQLException;
	public List<DeptVO> selectDeptCode() throws SQLException;
	public List<AdminVO> selectAdminCode() throws SQLException;
	public List<GradeVO> selectGradeCode() throws SQLException;
	public void updateDeptCode(DeptVO deptVO) throws SQLException;
	public void updateAdminCode(AdminVO adminVO) throws SQLException;
	public void updateGradeCode(GradeVO gradeVO) throws SQLException;
	public void deleteDeptCode(int deptNo) throws SQLException;
	public void deleteAdminCode(int adminNo) throws SQLException;
	public void deleteGradeCode(int gradeNo) throws SQLException;
	public DeptVO selectDeptCodeByDeptNo(int deptNo) throws SQLException;
	public AdminVO selectAdminCodeByAdminNo(int adminNo) throws SQLException;
	public GradeVO selectGradeCodeByGradeNo(int gradeNo) throws SQLException;
}